package com.lingz.manager.modules.wuxue.mapper;

import com.lingz.manager.config.mybatisplus.ExpandBaseMapper;
import com.lingz.manager.modules.wuxue.entity.WaterConservancyData;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;

import java.util.List;


/**
 * (WaterConservancyData)表数据库访问层
 *
 * @author makejava
 * @since 2023-12-08 14:40:59
 */
@Component
public interface WaterConservancyDataMapper extends ExpandBaseMapper<WaterConservancyData> {

    @Select("SELECT * FROM w_water_conservancy_data WHERE stcd = #{id} ORDER BY tm DESC LIMIT 5")
    List<WaterConservancyData> getLatestDataById(String id);
}
